[dbo].[asi_RebuildNameAllView]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_RebuildNameAllView

Property	Value
ANSI Nulls On
Quoted Identifier On

-- =============================================
-- Author:        Paul Bradshaw
-- Create date: Jan 30th, 2007
-- Description:    Rebuild Name_All View
-- =============================================
CREATE PROCEDURE asi_RebuildNameAllView
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    EXEC asi_DropNameAllView
    EXEC asi_BuildNameAllView
    EXEC asi_SetNameAllViewPermissions
END

GO